Drop extra index

Andrew Cantino 9 anos atrás
pai
commit
1e0664838d
2 arquivos alterados com 10 adições e 9 exclusões
  1. 5 0
      db/migrate/20140809211540_remove_service_index_on_user_id.rb
  2. 5 9
      db/schema.rb

+ 5 - 0
db/migrate/20140809211540_remove_service_index_on_user_id.rb

@@ -0,0 +1,5 @@
1
+class RemoveServiceIndexOnUserId < ActiveRecord::Migration
2
+  def change
3
+    remove_index :services, :user_id
4
+  end
5
+end

+ 5 - 9
db/schema.rb

@@ -11,10 +11,7 @@
11 11
 #
12 12
 # It's strongly recommended that you check this file into your version control system.
13 13
 
14
-ActiveRecord::Schema.define(version: 20140730005210) do
15
-
16
-  # These are extensions that must be enabled in order to support this database
17
-  enable_extension "plpgsql"
14
+ActiveRecord::Schema.define(version: 20140809211540) do
18 15
 
19 16
   create_table "agent_logs", force: true do |t|
20 17
     t.integer  "agent_id",                      null: false
@@ -120,10 +117,10 @@ ActiveRecord::Schema.define(version: 20140730005210) do
120 117
   add_index "scenarios", ["user_id", "guid"], name: "index_scenarios_on_user_id_and_guid", unique: true, using: :btree
121 118
 
122 119
   create_table "services", force: true do |t|
123
-    t.integer  "user_id"
124
-    t.string   "provider"
125
-    t.string   "name"
126
-    t.text     "token"
120
+    t.integer  "user_id",                       null: false
121
+    t.string   "provider",                      null: false
122
+    t.string   "name",                          null: false
123
+    t.text     "token",                         null: false
127 124
     t.text     "secret"
128 125
     t.text     "refresh_token"
129 126
     t.datetime "expires_at"
@@ -134,7 +131,6 @@ ActiveRecord::Schema.define(version: 20140730005210) do
134 131
   end
135 132
 
136 133
   add_index "services", ["user_id", "global"], name: "index_accounts_on_user_id_and_global", using: :btree
137
-  add_index "services", ["user_id"], name: "index_accounts_on_user_id", using: :btree
138 134
 
139 135
   create_table "user_credentials", force: true do |t|
140 136
     t.integer  "user_id",                           null: false